﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ConfExpertDataSet" targetNamespace="http://tempuri.org/ConfExpertDataSet.xsd" xmlns:mstns="http://tempuri.org/ConfExpertDataSet.xsd" xmlns="http://tempuri.org/ConfExpertDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ConfExpertConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConfExpertConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DynaCAD.Properties.Settings.GlobalReference.Default.ConfExpertConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAD_ParcaTableAdapter" GeneratorDataComponentClassName="CAD_ParcaTableAdapter" Name="CAD_Parca" UserDataComponentName="CAD_ParcaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConfExpertConnectionString (Settings)" DbObjectName="ConfExpert.dbo.CAD_Parca" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CAD_Parca] WHERE (([CAD_ParcaId] = @Original_CAD_ParcaId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CAD_ParcaId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAD_ParcaId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CAD_Parca] ([Ad], [Parca], [OnSol], [OnSag], [ArkaSol], [ArkaSag], [Detay0], [Detay1], [Detay2]) VALUES (@Ad, @Parca, @OnSol, @OnSag, @ArkaSol, @ArkaSag, @Detay0, @Detay1, @Detay2);
SELECT CAD_ParcaId, Ad, Parca, OnSol, OnSag, ArkaSol, ArkaSag, Detay0, Detay1, Detay2 FROM CAD_Parca WHERE (CAD_ParcaId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ad" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Parca" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Parca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OnSol" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OnSol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OnSag" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OnSag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArkaSol" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArkaSol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArkaSag" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArkaSag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Detay0" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Detay0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Detay1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Detay1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Detay2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Detay2" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CAD_ParcaId, Ad, Parca, OnSol, OnSag, ArkaSol, ArkaSag, Detay0, Detay1, Detay2 FROM dbo.CAD_Parca</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CAD_Parca] SET [Ad] = @Ad, [Parca] = @Parca, [OnSol] = @OnSol, [OnSag] = @OnSag, [ArkaSol] = @ArkaSol, [ArkaSag] = @ArkaSag, [Detay0] = @Detay0, [Detay1] = @Detay1, [Detay2] = @Detay2 WHERE (([CAD_ParcaId] = @Original_CAD_ParcaId));
SELECT CAD_ParcaId, Ad, Parca, OnSol, OnSag, ArkaSol, ArkaSag, Detay0, Detay1, Detay2 FROM CAD_Parca WHERE (CAD_ParcaId = @CAD_ParcaId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ad" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Parca" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Parca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OnSol" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OnSol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OnSag" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OnSag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArkaSol" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArkaSol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArkaSag" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArkaSag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Detay0" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Detay0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Detay1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Detay1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Detay2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Detay2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CAD_ParcaId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAD_ParcaId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CAD_ParcaId" ColumnName="CAD_ParcaId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CAD_ParcaId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CAD_ParcaId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CAD_ParcaId" DataSetColumn="CAD_ParcaId" />
              <Mapping SourceColumn="Ad" DataSetColumn="Ad" />
              <Mapping SourceColumn="Parca" DataSetColumn="Parca" />
              <Mapping SourceColumn="OnSol" DataSetColumn="OnSol" />
              <Mapping SourceColumn="OnSag" DataSetColumn="OnSag" />
              <Mapping SourceColumn="ArkaSol" DataSetColumn="ArkaSol" />
              <Mapping SourceColumn="ArkaSag" DataSetColumn="ArkaSag" />
              <Mapping SourceColumn="Detay0" DataSetColumn="Detay0" />
              <Mapping SourceColumn="Detay1" DataSetColumn="Detay1" />
              <Mapping SourceColumn="Detay2" DataSetColumn="Detay2" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAD_SablonTableAdapter" GeneratorDataComponentClassName="CAD_SablonTableAdapter" Name="CAD_Sablon" UserDataComponentName="CAD_SablonTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConfExpertConnectionString (Settings)" DbObjectName="ConfExpert.dbo.CAD_Sablon" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CAD_Sablon] WHERE (([SablonId] = @Original_SablonId) AND ((@IsNull_BrandId = 1 AND [BrandId] IS NULL) OR ([BrandId] = @Original_BrandId)) AND ((@IsNull_SeasonId = 1 AND [SeasonId] IS NULL) OR ([SeasonId] = @Original_SeasonId)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SablonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SablonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BrandId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BrandId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BrandId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BrandId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SeasonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SeasonId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SeasonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SeasonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CAD_Sablon] ([Ad], [Sablon], [On], [Arka], [BrandId], [SeasonId]) VALUES (@Ad, @Sablon, @On, @Arka, @BrandId, @SeasonId);
SELECT SablonId, Ad, Sablon, [On], Arka, BrandId, SeasonId FROM CAD_Sablon WHERE (SablonId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ad" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Sablon" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Sablon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@On" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="On" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Arka" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Arka" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BrandId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BrandId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SeasonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SeasonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SablonId, Ad, Sablon, [On], Arka, BrandId, SeasonId FROM dbo.CAD_Sablon</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CAD_Sablon] SET [Ad] = @Ad, [Sablon] = @Sablon, [On] = @On, [Arka] = @Arka, [BrandId] = @BrandId, [SeasonId] = @SeasonId WHERE (([SablonId] = @Original_SablonId) AND ((@IsNull_BrandId = 1 AND [BrandId] IS NULL) OR ([BrandId] = @Original_BrandId)) AND ((@IsNull_SeasonId = 1 AND [SeasonId] IS NULL) OR ([SeasonId] = @Original_SeasonId)));
SELECT SablonId, Ad, Sablon, [On], Arka, BrandId, SeasonId FROM CAD_Sablon WHERE (SablonId = @SablonId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ad" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Sablon" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Sablon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@On" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="On" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Arka" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Arka" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BrandId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BrandId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SeasonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SeasonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SablonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SablonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BrandId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BrandId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BrandId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BrandId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SeasonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SeasonId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SeasonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SeasonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SablonId" ColumnName="SablonId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SablonId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SablonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SablonId" DataSetColumn="SablonId" />
              <Mapping SourceColumn="Ad" DataSetColumn="Ad" />
              <Mapping SourceColumn="Sablon" DataSetColumn="Sablon" />
              <Mapping SourceColumn="On" DataSetColumn="On" />
              <Mapping SourceColumn="Arka" DataSetColumn="Arka" />
              <Mapping SourceColumn="BrandId" DataSetColumn="BrandId" />
              <Mapping SourceColumn="SeasonId" DataSetColumn="SeasonId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAD_ParcaTipiTableAdapter" GeneratorDataComponentClassName="CAD_ParcaTipiTableAdapter" Name="CAD_ParcaTipi" UserDataComponentName="CAD_ParcaTipiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConfExpertConnectionString (Settings)" DbObjectName="ConfExpert.dbo.CAD_ParcaTipi" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CAD_ParcaTipi] WHERE (([ParcaTipiId] = @Original_ParcaTipiId) AND ((@IsNull_ParcaAdi = 1 AND [ParcaAdi] IS NULL) OR ([ParcaAdi] = @Original_ParcaAdi)) AND ((@IsNull_OnArka = 1 AND [OnArka] IS NULL) OR ([OnArka] = @Original_OnArka)) AND ((@IsNull_SolSag = 1 AND [SolSag] IS NULL) OR ([SolSag] = @Original_SolSag)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ParcaTipiId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParcaTipiId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParcaAdi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParcaAdi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ParcaAdi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ParcaAdi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OnArka" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OnArka" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_OnArka" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="OnArka" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SolSag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SolSag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SolSag" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SolSag" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CAD_ParcaTipi] ([ParcaAdi], [OnArka], [SolSag]) VALUES (@ParcaAdi, @OnArka, @SolSag);
SELECT ParcaTipiId, ParcaAdi, OnArka, SolSag FROM CAD_ParcaTipi WHERE (ParcaTipiId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ParcaAdi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ParcaAdi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@OnArka" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="OnArka" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SolSag" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SolSag" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ParcaTipiId, ParcaAdi, OnArka, SolSag FROM dbo.CAD_ParcaTipi</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CAD_ParcaTipi] SET [ParcaAdi] = @ParcaAdi, [OnArka] = @OnArka, [SolSag] = @SolSag WHERE (([ParcaTipiId] = @Original_ParcaTipiId) AND ((@IsNull_ParcaAdi = 1 AND [ParcaAdi] IS NULL) OR ([ParcaAdi] = @Original_ParcaAdi)) AND ((@IsNull_OnArka = 1 AND [OnArka] IS NULL) OR ([OnArka] = @Original_OnArka)) AND ((@IsNull_SolSag = 1 AND [SolSag] IS NULL) OR ([SolSag] = @Original_SolSag)));
SELECT ParcaTipiId, ParcaAdi, OnArka, SolSag FROM CAD_ParcaTipi WHERE (ParcaTipiId = @ParcaTipiId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ParcaAdi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ParcaAdi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@OnArka" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="OnArka" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SolSag" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SolSag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ParcaTipiId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParcaTipiId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParcaAdi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParcaAdi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ParcaAdi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ParcaAdi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OnArka" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OnArka" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_OnArka" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="OnArka" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SolSag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SolSag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SolSag" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SolSag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ParcaTipiId" ColumnName="ParcaTipiId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ParcaTipiId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ParcaTipiId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ParcaTipiId" DataSetColumn="ParcaTipiId" />
              <Mapping SourceColumn="ParcaAdi" DataSetColumn="ParcaAdi" />
              <Mapping SourceColumn="OnArka" DataSetColumn="OnArka" />
              <Mapping SourceColumn="SolSag" DataSetColumn="SolSag" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ConfExpertDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ConfExpertDataSet" msprop:Generator_UserDSName="ConfExpertDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="CAD_Parca" msprop:Generator_TableClassName="CAD_ParcaDataTable" msprop:Generator_TableVarName="tableCAD_Parca" msprop:Generator_TablePropName="CAD_Parca" msprop:Generator_RowDeletingName="CAD_ParcaRowDeleting" msprop:Generator_RowChangingName="CAD_ParcaRowChanging" msprop:Generator_RowEvHandlerName="CAD_ParcaRowChangeEventHandler" msprop:Generator_RowDeletedName="CAD_ParcaRowDeleted" msprop:Generator_UserTableName="CAD_Parca" msprop:Generator_RowChangedName="CAD_ParcaRowChanged" msprop:Generator_RowEvArgName="CAD_ParcaRowChangeEvent" msprop:Generator_RowClassName="CAD_ParcaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CAD_ParcaId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCAD_ParcaId" msprop:Generator_ColumnPropNameInRow="CAD_ParcaId" msprop:Generator_ColumnPropNameInTable="CAD_ParcaIdColumn" msprop:Generator_UserColumnName="CAD_ParcaId" type="xs:int" />
              <xs:element name="Ad" msprop:Generator_ColumnVarNameInTable="columnAd" msprop:Generator_ColumnPropNameInRow="Ad" msprop:Generator_ColumnPropNameInTable="AdColumn" msprop:Generator_UserColumnName="Ad" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Parca" msprop:Generator_ColumnVarNameInTable="columnParca" msprop:Generator_ColumnPropNameInRow="Parca" msprop:Generator_ColumnPropNameInTable="ParcaColumn" msprop:Generator_UserColumnName="Parca" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="OnSol" msprop:Generator_ColumnVarNameInTable="columnOnSol" msprop:Generator_ColumnPropNameInRow="OnSol" msprop:Generator_ColumnPropNameInTable="OnSolColumn" msprop:Generator_UserColumnName="OnSol" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OnSag" msprop:Generator_ColumnVarNameInTable="columnOnSag" msprop:Generator_ColumnPropNameInRow="OnSag" msprop:Generator_ColumnPropNameInTable="OnSagColumn" msprop:Generator_UserColumnName="OnSag" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArkaSol" msprop:Generator_ColumnVarNameInTable="columnArkaSol" msprop:Generator_ColumnPropNameInRow="ArkaSol" msprop:Generator_ColumnPropNameInTable="ArkaSolColumn" msprop:Generator_UserColumnName="ArkaSol" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArkaSag" msprop:Generator_ColumnVarNameInTable="columnArkaSag" msprop:Generator_ColumnPropNameInRow="ArkaSag" msprop:Generator_ColumnPropNameInTable="ArkaSagColumn" msprop:Generator_UserColumnName="ArkaSag" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Detay0" msprop:Generator_ColumnVarNameInTable="columnDetay0" msprop:Generator_ColumnPropNameInRow="Detay0" msprop:Generator_ColumnPropNameInTable="Detay0Column" msprop:Generator_UserColumnName="Detay0" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Detay1" msprop:Generator_ColumnVarNameInTable="columnDetay1" msprop:Generator_ColumnPropNameInRow="Detay1" msprop:Generator_ColumnPropNameInTable="Detay1Column" msprop:Generator_UserColumnName="Detay1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Detay2" msprop:Generator_ColumnVarNameInTable="columnDetay2" msprop:Generator_ColumnPropNameInRow="Detay2" msprop:Generator_ColumnPropNameInTable="Detay2Column" msprop:Generator_UserColumnName="Detay2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAD_Sablon" msprop:Generator_TableClassName="CAD_SablonDataTable" msprop:Generator_TableVarName="tableCAD_Sablon" msprop:Generator_TablePropName="CAD_Sablon" msprop:Generator_RowDeletingName="CAD_SablonRowDeleting" msprop:Generator_RowChangingName="CAD_SablonRowChanging" msprop:Generator_RowEvHandlerName="CAD_SablonRowChangeEventHandler" msprop:Generator_RowDeletedName="CAD_SablonRowDeleted" msprop:Generator_UserTableName="CAD_Sablon" msprop:Generator_RowChangedName="CAD_SablonRowChanged" msprop:Generator_RowEvArgName="CAD_SablonRowChangeEvent" msprop:Generator_RowClassName="CAD_SablonRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SablonId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSablonId" msprop:Generator_ColumnPropNameInRow="SablonId" msprop:Generator_ColumnPropNameInTable="SablonIdColumn" msprop:Generator_UserColumnName="SablonId" type="xs:int" />
              <xs:element name="Ad" msprop:Generator_ColumnVarNameInTable="columnAd" msprop:Generator_ColumnPropNameInRow="Ad" msprop:Generator_ColumnPropNameInTable="AdColumn" msprop:Generator_UserColumnName="Ad" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sablon" msprop:Generator_ColumnVarNameInTable="columnSablon" msprop:Generator_ColumnPropNameInRow="Sablon" msprop:Generator_ColumnPropNameInTable="SablonColumn" msprop:Generator_UserColumnName="Sablon" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="On" msprop:Generator_ColumnVarNameInTable="columnOn" msprop:Generator_ColumnPropNameInRow="On" msprop:Generator_ColumnPropNameInTable="OnColumn" msprop:Generator_UserColumnName="On" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Arka" msprop:Generator_ColumnVarNameInTable="columnArka" msprop:Generator_ColumnPropNameInRow="Arka" msprop:Generator_ColumnPropNameInTable="ArkaColumn" msprop:Generator_UserColumnName="Arka" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BrandId" msprop:Generator_ColumnVarNameInTable="columnBrandId" msprop:Generator_ColumnPropNameInRow="BrandId" msprop:Generator_ColumnPropNameInTable="BrandIdColumn" msprop:Generator_UserColumnName="BrandId" type="xs:int" minOccurs="0" />
              <xs:element name="SeasonId" msprop:Generator_ColumnVarNameInTable="columnSeasonId" msprop:Generator_ColumnPropNameInRow="SeasonId" msprop:Generator_ColumnPropNameInTable="SeasonIdColumn" msprop:Generator_UserColumnName="SeasonId" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAD_ParcaTipi" msprop:Generator_TableClassName="CAD_ParcaTipiDataTable" msprop:Generator_TableVarName="tableCAD_ParcaTipi" msprop:Generator_TablePropName="CAD_ParcaTipi" msprop:Generator_RowDeletingName="CAD_ParcaTipiRowDeleting" msprop:Generator_RowChangingName="CAD_ParcaTipiRowChanging" msprop:Generator_RowEvHandlerName="CAD_ParcaTipiRowChangeEventHandler" msprop:Generator_RowDeletedName="CAD_ParcaTipiRowDeleted" msprop:Generator_UserTableName="CAD_ParcaTipi" msprop:Generator_RowChangedName="CAD_ParcaTipiRowChanged" msprop:Generator_RowEvArgName="CAD_ParcaTipiRowChangeEvent" msprop:Generator_RowClassName="CAD_ParcaTipiRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ParcaTipiId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnParcaTipiId" msprop:Generator_ColumnPropNameInRow="ParcaTipiId" msprop:Generator_ColumnPropNameInTable="ParcaTipiIdColumn" msprop:Generator_UserColumnName="ParcaTipiId" type="xs:int" />
              <xs:element name="ParcaAdi" msprop:Generator_ColumnVarNameInTable="columnParcaAdi" msprop:Generator_ColumnPropNameInRow="ParcaAdi" msprop:Generator_ColumnPropNameInTable="ParcaAdiColumn" msprop:Generator_UserColumnName="ParcaAdi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OnArka" msprop:Generator_ColumnVarNameInTable="columnOnArka" msprop:Generator_ColumnPropNameInRow="OnArka" msprop:Generator_ColumnPropNameInTable="OnArkaColumn" msprop:Generator_UserColumnName="OnArka" type="xs:boolean" minOccurs="0" />
              <xs:element name="SolSag" msprop:Generator_ColumnVarNameInTable="columnSolSag" msprop:Generator_ColumnPropNameInRow="SolSag" msprop:Generator_ColumnPropNameInTable="SolSagColumn" msprop:Generator_UserColumnName="SolSag" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAD_Parca" />
      <xs:field xpath="mstns:CAD_ParcaId" />
    </xs:unique>
    <xs:unique name="CAD_Sablon_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAD_Sablon" />
      <xs:field xpath="mstns:SablonId" />
    </xs:unique>
    <xs:unique name="CAD_ParcaTipi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAD_ParcaTipi" />
      <xs:field xpath="mstns:ParcaTipiId" />
    </xs:unique>
  </xs:element>
</xs:schema>